join employee and department table on view its not appearing in view mvc core
104
join employee and department table on view it's not appearing in view mvc core -
var query= (from x in dbquery.Employee join y in dbquery.Department on x.Emp_id equals y.Emp_id
where x.Emp_id==id select new {x.Emp_id, x.Emp_name,x.Emp_Address,x.Emp_Contact, y.dept_id,y.dept_name,y.salary}).ToList(); return View(query);